dataSource {
     pooling = true 
     
     // mysql
//     dbCreate = "update"      // one of 'create', 'create-drop','update'
//     url = "jdbc:mysql://localhost/test" 
//     driverClassName = "com.mysql.jdbc.Driver" 
//     username = "sa" 
//     password = ""

     
     //mssql2005
     dbCreate = "update"      // one of 'create', 'create-drop','update'
     url = "jdbc:sqlserver://127.0.0.1:1433;databaseName=kisdb" 
     driverClassName = "com.microsoft.sqlserver.jdbc.SQLServerDriver" 
     username = "sa" 
     password = "19780328"
}
hibernate {
    cache.use_second_level_cache=true
    cache.use_query_cache=true
    cache.provider_class='com.opensymphony.oscache.hibernate.OSCacheProvider'
}
// environment specific settings
environments {
	development {
        dataSource {
            pooling = true 
            dbCreate = "update"    // one of 'create', 'create-drop','update'
            url = "jdbc:sqlserver://127.0.0.1:1433;databaseName=kisdb" 
            logSql = true
        }
	}
	test {
		dataSource {
            pooling = true 
            dbCreate = "update"    // one of 'create', 'create-drop','update'
            url = "jdbc:sqlserver://127.0.0.1:1433;databaseName=kisdb" 
		}
	}
	production {
		dataSource {
            pooling = true 
            dbCreate = "update"    // one of 'create', 'create-drop','update'
            url = "jdbc:sqlserver://127.0.0.1:1433;databaseName=kisdb" 
		}
	}
}